{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from machine_lib import * "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "b'{\"user\":{\"id\":\"JW80368\"},\"token\":{\"expiry\":14400.0},\"permissions\":[\"CONSULTANT\",\"MULTI_SIMULATION\",\"PROD_ALPHAS\",\"REFERRAL\",\"VISUALIZATION\",\"WORKDAY\"]}'\n"
     ]
    }
   ],
   "source": [
    "s = login()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                   id  \\\n",
      "0          fnd65_allcap_sedol_52whigh   \n",
      "1         fnd65_allcap_sedol_60dsigma   \n",
      "2          fnd65_allcap_sedol_6351_rp   \n",
      "3        fnd65_allcap_sedol_actrtn12m   \n",
      "4        fnd65_allcap_sedol_actrtn18m   \n",
      "..                                ...   \n",
      "658      fnd65_pacific_sedol_yoychgda   \n",
      "659     fnd65_pacific_sedol_yoychggpm   \n",
      "660     fnd65_pacific_sedol_yoychgroa   \n",
      "661  fnd65_pacific_sedol_yoychgroeart   \n",
      "662  fnd65_pacific_sedol_yoychgroepct   \n",
      "\n",
      "                                           description  \\\n",
      "0    It is defined as the month-end price divided b...   \n",
      "1    Sigma is defined as the standard deviation of ...   \n",
      "2    It is defined as the moving average of a stock...   \n",
      "3    It is defined as the percent change in price f...   \n",
      "4    It is defined as the percent change in price f...   \n",
      "..                                                 ...   \n",
      "658  It is defined as the difference between the mo...   \n",
      "659  It is defined as the most recent quarterly rep...   \n",
      "660  It is defined as the most recent trailing 12-m...   \n",
      "661  It is defined as the yearly arithmetic change ...   \n",
      "662  It is defined as the yearly percentage change ...   \n",
      "\n",
      "                                               dataset  \\\n",
      "0    {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "1    {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "2    {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "3    {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "4    {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "..                                                 ...   \n",
      "658  {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "659  {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "660  {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "661  {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "662  {'id': 'fundamental65', 'name': 'Factor Ratios...   \n",
      "\n",
      "                             category  \\\n",
      "0    {'id': 'model', 'name': 'Model'}   \n",
      "1    {'id': 'model', 'name': 'Model'}   \n",
      "2    {'id': 'model', 'name': 'Model'}   \n",
      "3    {'id': 'model', 'name': 'Model'}   \n",
      "4    {'id': 'model', 'name': 'Model'}   \n",
      "..                                ...   \n",
      "658  {'id': 'model', 'name': 'Model'}   \n",
      "659  {'id': 'model', 'name': 'Model'}   \n",
      "660  {'id': 'model', 'name': 'Model'}   \n",
      "661  {'id': 'model', 'name': 'Model'}   \n",
      "662  {'id': 'model', 'name': 'Model'}   \n",
      "\n",
      "                                           subcategory region  delay universe  \\\n",
      "0    {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "1    {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "2    {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "3    {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "4    {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "..                                                 ...    ...    ...      ...   \n",
      "658  {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "659  {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "660  {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "661  {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "662  {'id': 'model-estimates-models', 'name': 'Esti...    KOR      1   TOP600   \n",
      "\n",
      "       type  coverage  userCount  alphaCount  pyramidMultiplier themes  \n",
      "0    MATRIX    1.0000         16          27                1.5     []  \n",
      "1    MATRIX    1.0000          8          12                1.5     []  \n",
      "2    MATRIX    1.0000          3           4                1.5     []  \n",
      "3    MATRIX    1.0000          7          11                1.5     []  \n",
      "4    MATRIX    1.0000          5          12                1.5     []  \n",
      "..      ...       ...        ...         ...                ...    ...  \n",
      "658  MATRIX    0.6074          0           0                1.5     []  \n",
      "659  MATRIX    0.5598          0           0                1.5     []  \n",
      "660  MATRIX    0.6045          2           6                1.5     []  \n",
      "661  MATRIX    0.5896          0           0                1.5     []  \n",
      "662  MATRIX    0.5694          1           1                1.5     []  \n",
      "\n",
      "[663 rows x 14 columns]\n"
     ]
    }
   ],
   "source": [
    "df = get_datafields(s, dataset_id = 'fundamental65', region='KOR', universe='TOP600')\n",
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['fnd65_allcap_sedol_52whigh', 'fnd65_allcap_sedol_60dsigma', 'fnd65_allcap_sedol_6351_rp', 'fnd65_allcap_sedol_actrtn12m', 'fnd65_allcap_sedol_actrtn18m', 'fnd65_allcap_sedol_actrtn1m', 'fnd65_allcap_sedol_actrtn24m', 'fnd65_allcap_sedol_actrtn2m', 'fnd65_allcap_sedol_actrtn36m', 'fnd65_allcap_sedol_actrtn3m', 'fnd65_allcap_sedol_actrtn60m', 'fnd65_allcap_sedol_actrtn60m12lag', 'fnd65_allcap_sedol_actrtn6m', 'fnd65_allcap_sedol_actrtn9m', 'fnd65_allcap_sedol_ad', 'fnd65_allcap_sedol_adpmoc', 'fnd65_allcap_sedol_ags', 'fnd65_allcap_sedol_alpha60m', 'fnd65_allcap_sedol_altmanz', 'fnd65_allcap_sedol_aoer', 'fnd65_allcap_sedol_aor', 'fnd65_allcap_sedol_apemtt', 'fnd65_allcap_sedol_apg', 'fnd65_allcap_sedol_apgghcy1_', 'fnd65_allcap_sedol_apgghcy3_', 'fnd65_allcap_sedol_apsales', 'fnd65_allcap_sedol_aspanratio', 'fnd65_allcap_sedol_aspemtty3gc', 'fnd65_allcap_sedol_astcomp', 'fnd65_allcap_sedol_astto', 'fnd65_allcap_sedol_avg10yep', 'fnd65_allcap_sedol_beta', 'fnd65_allcap_sedol_betasigma', 'fnd65_allcap_sedol_bmpo', 'fnd65_allcap_sedol_booklev', 'fnd65_allcap_sedol_bpemtt', 'fnd65_allcap_sedol_capacq', 'fnd65_allcap_sedol_capexast', 'fnd65_allcap_sedol_capexdeplink', 'fnd65_allcap_sedol_capexsale', 'fnd65_allcap_sedol_cashburnrate', 'fnd65_allcap_sedol_cashc', 'fnd65_allcap_sedol_cashp', 'fnd65_allcap_sedol_cashratio', 'fnd65_allcap_sedol_cashsale', 'fnd65_allcap_sedol_cashsev', 'fnd65_allcap_sedol_ccacw', 'fnd65_allcap_sedol_ceroe', 'fnd65_allcap_sedol_cfita', 'fnd65_allcap_sedol_cfleverage', 'fnd65_allcap_sedol_cfroi', 'fnd65_allcap_sedol_cg3yroic', 'fnd65_allcap_sedol_cg3ysales', 'fnd65_allcap_sedol_chg12mtotdebt', 'fnd65_allcap_sedol_chg3ycfast', 'fnd65_allcap_sedol_chg3yepsast', 'fnd65_allcap_sedol_chg3yepsp', 'fnd65_allcap_sedol_chg3yfcfast', 'fnd65_allcap_sedol_chg3yocfast', 'fnd65_allcap_sedol_chg6malpha18m', 'fnd65_allcap_sedol_chgalpha12m', 'fnd65_allcap_sedol_chgalpha36m', 'fnd65_allcap_sedol_chgars', 'fnd65_allcap_sedol_chginvavgast', 'fnd65_allcap_sedol_chgnoa', 'fnd65_allcap_sedol_chgollev', 'fnd65_allcap_sedol_chgqtrepssurp', 'fnd65_allcap_sedol_chgreccast', 'fnd65_allcap_sedol_chgsgasale', 'fnd65_allcap_sedol_chgvolpre4y', 'fnd65_allcap_sedol_cogsinvt', 'fnd65_allcap_sedol_coreepsp', 'fnd65_allcap_sedol_covol', 'fnd65_allcap_sedol_cpgspea2y', 'fnd65_allcap_sedol_curindbp_', 'fnd65_allcap_sedol_curindcfp_', 'fnd65_allcap_sedol_curinddivp_', 'fnd65_allcap_sedol_curindebitdap_', 'fnd65_allcap_sedol_curindep_', 'fnd65_allcap_sedol_curindfcfp_', 'fnd65_allcap_sedol_curindocfp_', 'fnd65_allcap_sedol_curindocfta_', 'fnd65_allcap_sedol_curindsp_', 'fnd65_allcap_sedol_curratio', 'fnd65_allcap_sedol_cvvolp20d', 'fnd65_allcap_sedol_cws', 'fnd65_allcap_sedol_d41isr', 'fnd65_allcap_sedol_dcc', 'fnd65_allcap_sedol_debtcf', 'fnd65_allcap_sedol_debtmktcap', 'fnd65_allcap_sedol_div5yg', 'fnd65_allcap_sedol_divcf', 'fnd65_allcap_sedol_divcov', 'fnd65_allcap_sedol_divgp', 'fnd65_allcap_sedol_divyield', 'fnd65_allcap_sedol_dpcapex', 'fnd65_allcap_sedol_dsu', 'fnd65_allcap_sedol_dtsm1_rd', 'fnd65_allcap_sedol_earningstorpedo', 'fnd65_allcap_sedol_earnshortfall', 'fnd65_allcap_sedol_ebitdadebt', 'fnd65_allcap_sedol_ebitdadebtchg', 'fnd65_allcap_sedol_ebitdaev', 'fnd65_allcap_sedol_ebitdap', 'fnd65_allcap_sedol_ed', 'fnd65_allcap_sedol_emeasales', 'fnd65_allcap_sedol_epschgetr', 'fnd65_allcap_sedol_equityto', 'fnd65_allcap_sedol_fc_curindfwdep_', 'fnd65_allcap_sedol_fc_dypeg', 'fnd65_allcap_sedol_fc_ebop', 'fnd65_allcap_sedol_fc_estep', 'fnd65_allcap_sedol_fc_fcfroey1p', 'fnd65_allcap_sedol_fc_fqsurstd', 'fnd65_allcap_sedol_fc_fwdroe', 'fnd65_allcap_sedol_fc_numest', 'fnd65_allcap_sedol_fc_numrevy1', 'fnd65_allcap_sedol_fc_rel5yfwdep', 'fnd65_allcap_sedol_fc_rev3y1', 'fnd65_allcap_sedol_fc_rev3y2', 'fnd65_allcap_sedol_fc_rev6', 'fnd65_allcap_sedol_fc_stdevfy1epsp', 'fnd65_allcap_sedol_fc_stdevfy2epsp', 'fnd65_allcap_sedol_fc_y2repsg', 'fnd65_allcap_sedol_fcfequity', 'fnd65_allcap_sedol_fcfghc', 'fnd65_allcap_sedol_fcfroi', 'fnd65_allcap_sedol_fcfsale', 'fnd65_allcap_sedol_fcfy3gc', 'fnd65_allcap_sedol_fcghc', 'fnd65_allcap_sedol_fcoghc', 'fnd65_allcap_sedol_fixastto', 'fnd65_allcap_sedol_flowratio', 'fnd65_allcap_sedol_fqsurstd60dlag', 'fnd65_allcap_sedol_fwdebitdaev', 'fnd65_allcap_sedol_gear', 'fnd65_allcap_sedol_grahamnum', 'fnd65_allcap_sedol_gspea2y_cf', 'fnd65_allcap_sedol_gtl', 'fnd65_allcap_sedol_ica', 'fnd65_allcap_sedol_idb', 'fnd65_allcap_sedol_indrelcroe_', 'fnd65_allcap_sedol_indrelrecd_', 'fnd65_allcap_sedol_indrelrtn4w_', 'fnd65_allcap_sedol_indrelrtn5d_', 'fnd65_allcap_sedol_inflation', 'fnd65_allcap_sedol_invast', 'fnd65_allcap_sedol_iqa', 'fnd65_allcap_sedol_irttmsalesev', 'fnd65_allcap_sedol_lagegp', 'fnd65_allcap_sedol_lasales', 'fnd65_allcap_sedol_lfd', 'fnd65_allcap_sedol_liqcoeff', 'fnd65_allcap_sedol_lumqca', 'fnd65_allcap_sedol_m42rav', 'fnd65_allcap_sedol_m6dn2ntr', 'fnd65_allcap_sedol_md', 'fnd65_allcap_sedol_milliq', 'fnd65_allcap_sedol_mktcappera', 'fnd65_allcap_sedol_mktlev', 'fnd65_allcap_sedol_mpg', 'fnd65_allcap_sedol_mpgghcy3_', 'fnd65_allcap_sedol_mpgy3gc', 'fnd65_allcap_sedol_mpn', 'fnd65_allcap_sedol_mpnghc', 'fnd65_allcap_sedol_mpoghc', 'fnd65_allcap_sedol_mpoy3gc', 'fnd65_allcap_sedol_mrspe_cf', 'fnd65_allcap_sedol_nasales', 'fnd65_allcap_sedol_netcashp', 'fnd65_allcap_sedol_netdebt', 'fnd65_allcap_sedol_netdebtebitda', 'fnd65_allcap_sedol_nfaldebt', 'fnd65_allcap_sedol_nla_u', 'fnd65_allcap_sedol_nlassets', 'fnd65_allcap_sedol_nlmc', 'fnd65_allcap_sedol_nlmc_u', 'fnd65_allcap_sedol_nlprice', 'fnd65_allcap_sedol_nlprice_usd', 'fnd65_allcap_sedol_nlsales', 'fnd65_allcap_sedol_nlsales_usd', 'fnd65_allcap_sedol_nlvolcap', 'fnd65_allcap_sedol_nnastp', 'fnd65_allcap_sedol_noato', 'fnd65_allcap_sedol_nopatmargin', 'fnd65_allcap_sedol_ntrm01ff', 'fnd65_allcap_sedol_numrevy2', 'fnd65_allcap_sedol_ocfast', 'fnd65_allcap_sedol_ocfmargin', 'fnd65_allcap_sedol_ocfratio', 'fnd65_allcap_sedol_ocfroi', 'fnd65_allcap_sedol_ohlsonscore', 'fnd65_allcap_sedol_oilprice', 'fnd65_allcap_sedol_ollev', 'fnd65_allcap_sedol_opincltd', 'fnd65_allcap_sedol_oplev', 'fnd65_allcap_sedol_otvni', 'fnd65_allcap_sedol_p50_200ratio', 'fnd65_allcap_sedol_past', 'fnd65_allcap_sedol_pau', 'fnd65_allcap_sedol_pb', 'fnd65_allcap_sedol_pbdwf', 'fnd65_allcap_sedol_pbroeresidual', 'fnd65_allcap_sedol_pbwt', 'fnd65_allcap_sedol_pca', 'fnd65_allcap_sedol_pcdwf', 'fnd65_allcap_sedol_pctabv260low', 'fnd65_allcap_sedol_pctchg3ycf', 'fnd65_allcap_sedol_pctchg3yeps', 'fnd65_allcap_sedol_pctchg3yfcf', 'fnd65_allcap_sedol_pctchg3yocf', 'fnd65_allcap_sedol_pctchgastto', 'fnd65_allcap_sedol_pctchgcf', 'fnd65_allcap_sedol_pctchgeps', 'fnd65_allcap_sedol_pctchgfcf', 'fnd65_allcap_sedol_pctchgocf', 'fnd65_allcap_sedol_pctchgqtrast', 'fnd65_allcap_sedol_pctchgqtrsales', 'fnd65_allcap_sedol_pcurlia', 'fnd65_allcap_sedol_pcwt', 'fnd65_allcap_sedol_pd09erpvc', 'fnd65_allcap_sedol_pe_wt', 'fnd65_allcap_sedol_pedu', 'fnd65_allcap_sedol_pedwf_cf', 'fnd65_allcap_sedol_pelh_cf', 'fnd65_allcap_sedol_perg', 'fnd65_allcap_sedol_pfcf_cf', 'fnd65_allcap_sedol_pfcfghc', 'fnd65_allcap_sedol_pfcfmtt', 'fnd65_allcap_sedol_pfcfy3ghc', 'fnd65_allcap_sedol_pfcghc', 'fnd65_allcap_sedol_pfcmtt', 'fnd65_allcap_sedol_pfcoghc', 'fnd65_allcap_sedol_pfcomtt', 'fnd65_allcap_sedol_pfcoy3ghc', 'fnd65_allcap_sedol_pfcy3ghc', 'fnd65_allcap_sedol_pfgmtt', 'fnd65_allcap_sedol_pge_cf', 'fnd65_allcap_sedol_pi', 'fnd65_allcap_sedol_pinoa', 'fnd65_allcap_sedol_ppa', 'fnd65_allcap_sedol_pqipmtt', 'fnd65_allcap_sedol_prc', 'fnd65_allcap_sedol_ps_wt', 'fnd65_allcap_sedol_psdwf', 'fnd65_allcap_sedol_psmtt', 'fnd65_allcap_sedol_pspeghc', 'fnd65_allcap_sedol_pu', 'fnd65_allcap_sedol_pvan', 'fnd65_allcap_sedol_rationalalpha', 'fnd65_allcap_sedol_ratrev6m', 'fnd65_allcap_sedol_rau', 'fnd65_allcap_sedol_rdsale', 'fnd65_allcap_sedol_reinrate', 'fnd65_allcap_sedol_rel5ybp', 'fnd65_allcap_sedol_rel5ycfp', 'fnd65_allcap_sedol_rel5ydivp', 'fnd65_allcap_sedol_rel5yebitdap', 'fnd65_allcap_sedol_rel5yep', 'fnd65_allcap_sedol_rel5yfcfp', 'fnd65_allcap_sedol_rel5yocfp', 'fnd65_allcap_sedol_rel5ysp', 'fnd65_allcap_sedol_relpricestrength_', 'fnd65_allcap_sedol_rerror60m', 'fnd65_allcap_sedol_rev3my1std', 'fnd65_allcap_sedol_rev3my2std', 'fnd65_allcap_sedol_rev6fy2', 'fnd65_allcap_sedol_roe', 'fnd65_allcap_sedol_roic', 'fnd65_allcap_sedol_rp', 'fnd65_allcap_sedol_rq', 'fnd65_allcap_sedol_rqi_rd', 'fnd65_allcap_sedol_saleeps', 'fnd65_allcap_sedol_saleg5y', 'fnd65_allcap_sedol_salegpm', 'fnd65_allcap_sedol_salerec', 'fnd65_allcap_sedol_sh', 'fnd65_allcap_sedol_sharechg', 'fnd65_allcap_sedol_sighc', 'fnd65_allcap_sedol_sigma', 'fnd65_allcap_sedol_skew90cortn', 'fnd65_allcap_sedol_skew90drtn', 'fnd65_allcap_sedol_slope4qeps5y', 'fnd65_allcap_sedol_slope52wp', 'fnd65_allcap_sedol_slope66wp', 'fnd65_allcap_sedol_spe1yfvc_cf', 'fnd65_allcap_sedol_spe2yfvc_cf', 'fnd65_allcap_sedol_spefcn', 'fnd65_allcap_sedol_speghc', 'fnd65_allcap_sedol_stockrating', 'fnd65_allcap_sedol_surp', 'fnd65_allcap_sedol_susgrowth', 'fnd65_allcap_sedol_tobinq', 'fnd65_allcap_sedol_totalcov', 'fnd65_allcap_sedol_totalsaleg', 'fnd65_allcap_sedol_tstalp', 'fnd65_allcap_sedol_ttmaccu', 'fnd65_allcap_sedol_ttmcapexp', 'fnd65_allcap_sedol_ttmopincev', 'fnd65_allcap_sedol_ttmsaleev', 'fnd65_allcap_sedol_tw_ebitdaev', 'fnd65_allcap_sedol_twepsrev', 'fnd65_allcap_sedol_twepsstdrev', 'fnd65_allcap_sedol_varresirtn', 'fnd65_allcap_sedol_vefcfmtt', 'fnd65_allcap_sedol_vefcomtt', 'fnd65_allcap_sedol_vesspem21f_cf', 'fnd65_allcap_sedol_visiratio', 'fnd65_allcap_sedol_vnicw', 'fnd65_allcap_sedol_vniu', 'fnd65_allcap_sedol_voctni', 'fnd65_allcap_sedol_volpre6m', 'fnd65_allcap_sedol_volto', 'fnd65_allcap_sedol_w57w03_rp', 'fnd65_allcap_sedol_w62isr', 'fnd65_allcap_sedol_w93ntr', 'fnd65_allcap_sedol_wcast', 'fnd65_allcap_sedol_xiv', 'fnd65_allcap_sedol_y5speq4rqsr', 'fnd65_allcap_sedol_y5speq4vc', 'fnd65_allcap_sedol_ydp_cf', 'fnd65_allcap_sedol_yen', 'fnd65_allcap_sedol_yieldsprd', 'fnd65_allcap_sedol_yoychgaa', 'fnd65_allcap_sedol_yoychgcr', 'fnd65_allcap_sedol_yoychgda', 'fnd65_allcap_sedol_yoychggpm', 'fnd65_allcap_sedol_yoychgroa', 'fnd65_allcap_sedol_yoychgroeart', 'fnd65_allcap_sedol_yoychgroepct', 'fnd65_pacific_sedol_52whigh', 'fnd65_pacific_sedol_60dsigma', 'fnd65_pacific_sedol_6351_rp', 'fnd65_pacific_sedol_actrtn12m', 'fnd65_pacific_sedol_actrtn18m', 'fnd65_pacific_sedol_actrtn1m', 'fnd65_pacific_sedol_actrtn24m', 'fnd65_pacific_sedol_actrtn2m', 'fnd65_pacific_sedol_actrtn36m', 'fnd65_pacific_sedol_actrtn3m', 'fnd65_pacific_sedol_actrtn60m', 'fnd65_pacific_sedol_actrtn60m12lag', 'fnd65_pacific_sedol_actrtn6m', 'fnd65_pacific_sedol_actrtn9m', 'fnd65_pacific_sedol_ad', 'fnd65_pacific_sedol_adpmoc', 'fnd65_pacific_sedol_ags', 'fnd65_pacific_sedol_alpha60m', 'fnd65_pacific_sedol_altmanz', 'fnd65_pacific_sedol_aoer', 'fnd65_pacific_sedol_aor', 'fnd65_pacific_sedol_apemtt', 'fnd65_pacific_sedol_apg', 'fnd65_pacific_sedol_apgghcy1_', 'fnd65_pacific_sedol_apgghcy3_', 'fnd65_pacific_sedol_apsales', 'fnd65_pacific_sedol_aspanratio', 'fnd65_pacific_sedol_aspemtty3gc', 'fnd65_pacific_sedol_astcomp', 'fnd65_pacific_sedol_astto', 'fnd65_pacific_sedol_avg10yep', 'fnd65_pacific_sedol_beta', 'fnd65_pacific_sedol_betasigma', 'fnd65_pacific_sedol_bmpo', 'fnd65_pacific_sedol_booklev', 'fnd65_pacific_sedol_bpemtt', 'fnd65_pacific_sedol_capacq', 'fnd65_pacific_sedol_capexast', 'fnd65_pacific_sedol_capexdeplink', 'fnd65_pacific_sedol_capexsale', 'fnd65_pacific_sedol_cashburnrate', 'fnd65_pacific_sedol_cashc', 'fnd65_pacific_sedol_cashp', 'fnd65_pacific_sedol_cashratio', 'fnd65_pacific_sedol_cashsale', 'fnd65_pacific_sedol_cashsev', 'fnd65_pacific_sedol_ccacw', 'fnd65_pacific_sedol_ceroe', 'fnd65_pacific_sedol_cfita', 'fnd65_pacific_sedol_cfleverage', 'fnd65_pacific_sedol_cfroi', 'fnd65_pacific_sedol_cg3yroic', 'fnd65_pacific_sedol_cg3ysales', 'fnd65_pacific_sedol_chg12mtotdebt', 'fnd65_pacific_sedol_chg3ycfast', 'fnd65_pacific_sedol_chg3yepsast', 'fnd65_pacific_sedol_chg3yepsp', 'fnd65_pacific_sedol_chg3yfcfast', 'fnd65_pacific_sedol_chg3yocfast', 'fnd65_pacific_sedol_chg6malpha18m', 'fnd65_pacific_sedol_chgalpha12m', 'fnd65_pacific_sedol_chgalpha36m', 'fnd65_pacific_sedol_chgars', 'fnd65_pacific_sedol_chginvavgast', 'fnd65_pacific_sedol_chgnoa', 'fnd65_pacific_sedol_chgollev', 'fnd65_pacific_sedol_chgqtrepssurp', 'fnd65_pacific_sedol_chgreccast', 'fnd65_pacific_sedol_chgsgasale', 'fnd65_pacific_sedol_chgvolpre4y', 'fnd65_pacific_sedol_cogsinvt', 'fnd65_pacific_sedol_coreepsp', 'fnd65_pacific_sedol_covol', 'fnd65_pacific_sedol_cpgspea2y', 'fnd65_pacific_sedol_curindbp_', 'fnd65_pacific_sedol_curindcfp_', 'fnd65_pacific_sedol_curinddivp_', 'fnd65_pacific_sedol_curindebitdap_', 'fnd65_pacific_sedol_curindep_', 'fnd65_pacific_sedol_curindfcfp_', 'fnd65_pacific_sedol_curindocfp_', 'fnd65_pacific_sedol_curindocfta_', 'fnd65_pacific_sedol_curindsp_', 'fnd65_pacific_sedol_curratio', 'fnd65_pacific_sedol_cvvolp20d', 'fnd65_pacific_sedol_cws', 'fnd65_pacific_sedol_d41isr', 'fnd65_pacific_sedol_dcc', 'fnd65_pacific_sedol_debtcf', 'fnd65_pacific_sedol_debtmktcap', 'fnd65_pacific_sedol_div5yg', 'fnd65_pacific_sedol_divcf', 'fnd65_pacific_sedol_divcov', 'fnd65_pacific_sedol_divgp', 'fnd65_pacific_sedol_divyield', 'fnd65_pacific_sedol_dpcapex', 'fnd65_pacific_sedol_dsu', 'fnd65_pacific_sedol_dtsm1_rd', 'fnd65_pacific_sedol_earningstorpedo', 'fnd65_pacific_sedol_earnshortfall', 'fnd65_pacific_sedol_ebitdadebt', 'fnd65_pacific_sedol_ebitdadebtchg', 'fnd65_pacific_sedol_ebitdaev', 'fnd65_pacific_sedol_ebitdap', 'fnd65_pacific_sedol_ed', 'fnd65_pacific_sedol_emeasales', 'fnd65_pacific_sedol_epschgetr', 'fnd65_pacific_sedol_equityto', 'fnd65_pacific_sedol_fc_curindfwdep_', 'fnd65_pacific_sedol_fc_dypeg', 'fnd65_pacific_sedol_fc_ebop', 'fnd65_pacific_sedol_fc_estep', 'fnd65_pacific_sedol_fc_fcfroey1p', 'fnd65_pacific_sedol_fc_fqsurstd', 'fnd65_pacific_sedol_fc_fwdroe', 'fnd65_pacific_sedol_fc_numest', 'fnd65_pacific_sedol_fc_numrevy1', 'fnd65_pacific_sedol_fc_rel5yfwdep', 'fnd65_pacific_sedol_fc_rev3y1', 'fnd65_pacific_sedol_fc_rev3y2', 'fnd65_pacific_sedol_fc_rev6', 'fnd65_pacific_sedol_fc_stdevfy1epsp', 'fnd65_pacific_sedol_fc_stdevfy2epsp', 'fnd65_pacific_sedol_fc_y2repsg', 'fnd65_pacific_sedol_fcfequity', 'fnd65_pacific_sedol_fcfghc', 'fnd65_pacific_sedol_fcfroi', 'fnd65_pacific_sedol_fcfsale', 'fnd65_pacific_sedol_fcfy3gc', 'fnd65_pacific_sedol_fcghc', 'fnd65_pacific_sedol_fcoghc', 'fnd65_pacific_sedol_fixastto', 'fnd65_pacific_sedol_flowratio', 'fnd65_pacific_sedol_fqsurstd60dlag', 'fnd65_pacific_sedol_fwdebitdaev', 'fnd65_pacific_sedol_gear', 'fnd65_pacific_sedol_grahamnum', 'fnd65_pacific_sedol_gspea2y_cf', 'fnd65_pacific_sedol_gtl', 'fnd65_pacific_sedol_gtlm6ghc', 'fnd65_pacific_sedol_ica', 'fnd65_pacific_sedol_idb', 'fnd65_pacific_sedol_indrelcroe_', 'fnd65_pacific_sedol_indrelrecd_', 'fnd65_pacific_sedol_indrelrtn4w_', 'fnd65_pacific_sedol_indrelrtn5d_', 'fnd65_pacific_sedol_inflation', 'fnd65_pacific_sedol_invast', 'fnd65_pacific_sedol_iqa', 'fnd65_pacific_sedol_irttmsalesev', 'fnd65_pacific_sedol_lagegp', 'fnd65_pacific_sedol_lasales', 'fnd65_pacific_sedol_lfd', 'fnd65_pacific_sedol_liqcoeff', 'fnd65_pacific_sedol_lumqca', 'fnd65_pacific_sedol_m42rav', 'fnd65_pacific_sedol_m6dn2ntr', 'fnd65_pacific_sedol_md', 'fnd65_pacific_sedol_milliq', 'fnd65_pacific_sedol_mktcappera', 'fnd65_pacific_sedol_mktlev', 'fnd65_pacific_sedol_mpg', 'fnd65_pacific_sedol_mpgghcy3_', 'fnd65_pacific_sedol_mpgy3gc', 'fnd65_pacific_sedol_mpn', 'fnd65_pacific_sedol_mpnghc', 'fnd65_pacific_sedol_mpoghc', 'fnd65_pacific_sedol_mpoy3gc', 'fnd65_pacific_sedol_mrspe_cf', 'fnd65_pacific_sedol_nasales', 'fnd65_pacific_sedol_netcashp', 'fnd65_pacific_sedol_netdebt', 'fnd65_pacific_sedol_netdebtebitda', 'fnd65_pacific_sedol_nfaldebt', 'fnd65_pacific_sedol_niper', 'fnd65_pacific_sedol_nla_u', 'fnd65_pacific_sedol_nlassets', 'fnd65_pacific_sedol_nlmc', 'fnd65_pacific_sedol_nlmc_u', 'fnd65_pacific_sedol_nlprice', 'fnd65_pacific_sedol_nlprice_usd', 'fnd65_pacific_sedol_nlsales', 'fnd65_pacific_sedol_nlsales_usd', 'fnd65_pacific_sedol_nlvolcap', 'fnd65_pacific_sedol_nnastp', 'fnd65_pacific_sedol_noato', 'fnd65_pacific_sedol_nopatmargin', 'fnd65_pacific_sedol_ntrm01ff', 'fnd65_pacific_sedol_numrevy2', 'fnd65_pacific_sedol_ocfast', 'fnd65_pacific_sedol_ocfmargin', 'fnd65_pacific_sedol_ocfratio', 'fnd65_pacific_sedol_ocfroi', 'fnd65_pacific_sedol_ohlsonscore', 'fnd65_pacific_sedol_oilprice', 'fnd65_pacific_sedol_ollev', 'fnd65_pacific_sedol_opincltd', 'fnd65_pacific_sedol_oplev', 'fnd65_pacific_sedol_otvni', 'fnd65_pacific_sedol_p50_200ratio', 'fnd65_pacific_sedol_past', 'fnd65_pacific_sedol_pau', 'fnd65_pacific_sedol_pb', 'fnd65_pacific_sedol_pbdwf', 'fnd65_pacific_sedol_pbroeresidual', 'fnd65_pacific_sedol_pbwt', 'fnd65_pacific_sedol_pca', 'fnd65_pacific_sedol_pcdwf', 'fnd65_pacific_sedol_pctabv260low', 'fnd65_pacific_sedol_pctchg3ycf', 'fnd65_pacific_sedol_pctchg3yeps', 'fnd65_pacific_sedol_pctchg3yfcf', 'fnd65_pacific_sedol_pctchg3yocf', 'fnd65_pacific_sedol_pctchgastto', 'fnd65_pacific_sedol_pctchgcf', 'fnd65_pacific_sedol_pctchgeps', 'fnd65_pacific_sedol_pctchgfcf', 'fnd65_pacific_sedol_pctchgocf', 'fnd65_pacific_sedol_pctchgqtrast', 'fnd65_pacific_sedol_pctchgqtrsales', 'fnd65_pacific_sedol_pcurlia', 'fnd65_pacific_sedol_pcwt', 'fnd65_pacific_sedol_pd09erpvc', 'fnd65_pacific_sedol_pe_wt', 'fnd65_pacific_sedol_pedu', 'fnd65_pacific_sedol_pedwf_cf', 'fnd65_pacific_sedol_pelh_cf', 'fnd65_pacific_sedol_perg', 'fnd65_pacific_sedol_pfcf_cf', 'fnd65_pacific_sedol_pfcfghc', 'fnd65_pacific_sedol_pfcfmtt', 'fnd65_pacific_sedol_pfcfy3ghc', 'fnd65_pacific_sedol_pfcghc', 'fnd65_pacific_sedol_pfcmtt', 'fnd65_pacific_sedol_pfcoghc', 'fnd65_pacific_sedol_pfcomtt', 'fnd65_pacific_sedol_pfcoy3ghc', 'fnd65_pacific_sedol_pfcy3ghc', 'fnd65_pacific_sedol_pfgmtt', 'fnd65_pacific_sedol_pge_cf', 'fnd65_pacific_sedol_pi', 'fnd65_pacific_sedol_pinoa', 'fnd65_pacific_sedol_ppa', 'fnd65_pacific_sedol_pqipmtt', 'fnd65_pacific_sedol_prc', 'fnd65_pacific_sedol_ps_wt', 'fnd65_pacific_sedol_psdwf', 'fnd65_pacific_sedol_psmtt', 'fnd65_pacific_sedol_pspeghc', 'fnd65_pacific_sedol_pu', 'fnd65_pacific_sedol_pvan', 'fnd65_pacific_sedol_rationalalpha', 'fnd65_pacific_sedol_ratrev6m', 'fnd65_pacific_sedol_rau', 'fnd65_pacific_sedol_rdsale', 'fnd65_pacific_sedol_reinrate', 'fnd65_pacific_sedol_rel5ybp', 'fnd65_pacific_sedol_rel5ycfp', 'fnd65_pacific_sedol_rel5ydivp', 'fnd65_pacific_sedol_rel5yebitdap', 'fnd65_pacific_sedol_rel5yep', 'fnd65_pacific_sedol_rel5yfcfp', 'fnd65_pacific_sedol_rel5yocfp', 'fnd65_pacific_sedol_rel5ysp', 'fnd65_pacific_sedol_relpricestrength_', 'fnd65_pacific_sedol_rerror60m', 'fnd65_pacific_sedol_rev3my1std', 'fnd65_pacific_sedol_rev3my2std', 'fnd65_pacific_sedol_rev6fy2', 'fnd65_pacific_sedol_revper', 'fnd65_pacific_sedol_roe', 'fnd65_pacific_sedol_roic', 'fnd65_pacific_sedol_rp', 'fnd65_pacific_sedol_rq', 'fnd65_pacific_sedol_rqi_rd', 'fnd65_pacific_sedol_saleeps', 'fnd65_pacific_sedol_saleg5y', 'fnd65_pacific_sedol_salegpm', 'fnd65_pacific_sedol_salerec', 'fnd65_pacific_sedol_sh', 'fnd65_pacific_sedol_sharechg', 'fnd65_pacific_sedol_sighc', 'fnd65_pacific_sedol_sigma', 'fnd65_pacific_sedol_skew90cortn', 'fnd65_pacific_sedol_skew90drtn', 'fnd65_pacific_sedol_slope4qeps5y', 'fnd65_pacific_sedol_slope52wp', 'fnd65_pacific_sedol_slope66wp', 'fnd65_pacific_sedol_spe1yfvc_cf', 'fnd65_pacific_sedol_spe2yfvc_cf', 'fnd65_pacific_sedol_spefcn', 'fnd65_pacific_sedol_speghc', 'fnd65_pacific_sedol_stockrating', 'fnd65_pacific_sedol_surp', 'fnd65_pacific_sedol_susgrowth', 'fnd65_pacific_sedol_tobinq', 'fnd65_pacific_sedol_totalcov', 'fnd65_pacific_sedol_totalsaleg', 'fnd65_pacific_sedol_tstalp', 'fnd65_pacific_sedol_ttmaccu', 'fnd65_pacific_sedol_ttmcapexp', 'fnd65_pacific_sedol_ttmopincev', 'fnd65_pacific_sedol_ttmsaleev', 'fnd65_pacific_sedol_tw_ebitdaev', 'fnd65_pacific_sedol_twepsrev', 'fnd65_pacific_sedol_twepsstdrev', 'fnd65_pacific_sedol_varresirtn', 'fnd65_pacific_sedol_vefcfmtt', 'fnd65_pacific_sedol_vefcomtt', 'fnd65_pacific_sedol_vesspem21f_cf', 'fnd65_pacific_sedol_visiratio', 'fnd65_pacific_sedol_vnicw', 'fnd65_pacific_sedol_vniu', 'fnd65_pacific_sedol_voctni', 'fnd65_pacific_sedol_volpre6m', 'fnd65_pacific_sedol_volto', 'fnd65_pacific_sedol_w57w03_rp', 'fnd65_pacific_sedol_w62isr', 'fnd65_pacific_sedol_w93ntr', 'fnd65_pacific_sedol_wcast', 'fnd65_pacific_sedol_xiv', 'fnd65_pacific_sedol_y5speq4rqsr', 'fnd65_pacific_sedol_y5speq4vc', 'fnd65_pacific_sedol_ydp_cf', 'fnd65_pacific_sedol_yen', 'fnd65_pacific_sedol_yieldsprd', 'fnd65_pacific_sedol_yoychgaa', 'fnd65_pacific_sedol_yoychgcr', 'fnd65_pacific_sedol_yoychgda', 'fnd65_pacific_sedol_yoychggpm', 'fnd65_pacific_sedol_yoychgroa', 'fnd65_pacific_sedol_yoychgroeart', 'fnd65_pacific_sedol_yoychgroepct']\n",
      "['winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_6351_rp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn12m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn18m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn1m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn24m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn2m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn36m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn3m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn60m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn60m12lag, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn6m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_actrtn9m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ad, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_adpmoc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ags, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_alpha60m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_altmanz, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_aoer, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_aor, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_apemtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_apg, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_apgghcy1_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_apgghcy3_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_apsales, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_aspanratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_aspemtty3gc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_astcomp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_astto, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_avg10yep, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_beta, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_betasigma, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_bmpo, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_booklev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_bpemtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_capacq, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_capexast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_capexdeplink, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_capexsale, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cashburnrate, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cashc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cashp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cashratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cashsale, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cashsev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ccacw, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ceroe, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cfita, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cfleverage, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cfroi, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cg3yroic, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cg3ysales, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chg12mtotdebt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chg3ycfast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chg3yepsast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chg3yepsp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chg3yfcfast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chg3yocfast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chg6malpha18m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chgalpha12m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chgalpha36m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chgars, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chginvavgast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chgnoa, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chgollev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chgqtrepssurp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chgreccast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chgsgasale, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_chgvolpre4y, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cogsinvt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_coreepsp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_covol, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cpgspea2y, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curindbp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curindcfp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curinddivp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curindebitdap_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curindep_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curindfcfp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curindocfp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curindocfta_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curindsp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_curratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cvvolp20d, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_cws, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_d41isr, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_dcc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_debtcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_debtmktcap, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_div5yg, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_divcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_divcov, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_divgp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_divyield, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_dpcapex, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_dsu, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_dtsm1_rd, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_earningstorpedo, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_earnshortfall, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ebitdadebt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ebitdadebtchg, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ebitdaev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ebitdap, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ed, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_emeasales, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_epschgetr, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_equityto, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_curindfwdep_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_dypeg, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_ebop, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_estep, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_fcfroey1p, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_fqsurstd, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_fwdroe, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_numest, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_numrevy1, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_rel5yfwdep, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_rev3y1, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_rev3y2, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_rev6, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_stdevfy1epsp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_stdevfy2epsp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fc_y2repsg, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fcfequity, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fcfghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fcfroi, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fcfsale, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fcfy3gc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fcghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fcoghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fixastto, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_flowratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fqsurstd60dlag, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_fwdebitdaev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_gear, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_grahamnum, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_gspea2y_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_gtl, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ica, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_idb, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_indrelcroe_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_indrelrecd_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_indrelrtn4w_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_indrelrtn5d_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_inflation, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_invast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_iqa, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_irttmsalesev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_lagegp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_lasales, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_lfd, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_liqcoeff, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_lumqca, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_m42rav, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_m6dn2ntr, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_md, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_milliq, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mktcappera, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mktlev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mpg, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mpgghcy3_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mpgy3gc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mpn, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mpnghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mpoghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mpoy3gc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_mrspe_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nasales, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_netcashp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_netdebt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_netdebtebitda, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nfaldebt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nla_u, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nlassets, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nlmc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nlmc_u, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nlprice, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nlprice_usd, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nlsales, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nlsales_usd, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nlvolcap, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nnastp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_noato, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_nopatmargin, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ntrm01ff, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_numrevy2, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ocfast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ocfmargin, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ocfratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ocfroi, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ohlsonscore, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_oilprice, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ollev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_opincltd, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_oplev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_otvni, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_p50_200ratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_past, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pau, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pb, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pbdwf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pbroeresidual, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pbwt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pca, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pcdwf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctabv260low, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchg3ycf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchg3yeps, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchg3yfcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchg3yocf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchgastto, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchgcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchgeps, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchgfcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchgocf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchgqtrast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pctchgqtrsales, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pcurlia, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pcwt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pd09erpvc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pe_wt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pedu, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pedwf_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pelh_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_perg, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcf_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcfghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcfmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcfy3ghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcoghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcomtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcoy3ghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfcy3ghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pfgmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pge_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pi, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pinoa, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ppa, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pqipmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_prc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ps_wt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_psdwf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_psmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pspeghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pu, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_pvan, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rationalalpha, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ratrev6m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rau, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rdsale, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_reinrate, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rel5ybp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rel5ycfp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rel5ydivp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rel5yebitdap, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rel5yep, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rel5yfcfp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rel5yocfp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rel5ysp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_relpricestrength_, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rerror60m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rev3my1std, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rev3my2std, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rev6fy2, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_roe, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_roic, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rq, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_rqi_rd, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_saleeps, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_saleg5y, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_salegpm, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_salerec, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_sh, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_sharechg, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_sighc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_sigma, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_skew90cortn, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_skew90drtn, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_slope4qeps5y, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_slope52wp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_slope66wp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_spe1yfvc_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_spe2yfvc_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_spefcn, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_speghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_stockrating, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_surp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_susgrowth, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_tobinq, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_totalcov, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_totalsaleg, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_tstalp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ttmaccu, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ttmcapexp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ttmopincev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ttmsaleev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_tw_ebitdaev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_twepsrev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_twepsstdrev, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_varresirtn, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_vefcfmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_vefcomtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_vesspem21f_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_visiratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_vnicw, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_vniu, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_voctni, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_volpre6m, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_volto, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_w57w03_rp, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_w62isr, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_w93ntr, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_wcast, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_xiv, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_y5speq4rqsr, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_y5speq4vc, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_ydp_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_yen, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_yieldsprd, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_yoychgaa, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_yoychgcr, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_yoychgda, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_yoychggpm, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_yoychgroa, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_yoychgroeart, 120), std=4)', 'winsorize(ts_backfill(fnd65_allcap_sedol_yoychgroepct, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_52whigh, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_60dsigma, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_6351_rp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn12m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn18m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn1m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn24m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn2m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn36m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn3m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn60m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn60m12lag, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn6m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_actrtn9m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ad, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_adpmoc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ags, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_alpha60m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_altmanz, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_aoer, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_aor, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_apemtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_apg, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_apgghcy1_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_apgghcy3_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_apsales, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_aspanratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_aspemtty3gc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_astcomp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_astto, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_avg10yep, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_beta, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_betasigma, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_bmpo, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_booklev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_bpemtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_capacq, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_capexast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_capexdeplink, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_capexsale, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cashburnrate, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cashc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cashp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cashratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cashsale, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cashsev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ccacw, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ceroe, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cfita, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cfleverage, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cfroi, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cg3yroic, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cg3ysales, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chg12mtotdebt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chg3ycfast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chg3yepsast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chg3yepsp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chg3yfcfast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chg3yocfast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chg6malpha18m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chgalpha12m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chgalpha36m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chgars, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chginvavgast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chgnoa, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chgollev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chgqtrepssurp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chgreccast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chgsgasale, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_chgvolpre4y, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cogsinvt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_coreepsp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_covol, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cpgspea2y, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curindbp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curindcfp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curinddivp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curindebitdap_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curindep_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curindfcfp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curindocfp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curindocfta_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curindsp_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_curratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cvvolp20d, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_cws, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_d41isr, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_dcc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_debtcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_debtmktcap, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_div5yg, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_divcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_divcov, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_divgp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_divyield, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_dpcapex, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_dsu, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_dtsm1_rd, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_earningstorpedo, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_earnshortfall, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ebitdadebt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ebitdadebtchg, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ebitdaev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ebitdap, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ed, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_emeasales, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_epschgetr, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_equityto, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_curindfwdep_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_dypeg, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_ebop, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_estep, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_fcfroey1p, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_fqsurstd, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_fwdroe, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_numest, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_numrevy1, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_rel5yfwdep, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_rev3y1, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_rev3y2, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_rev6, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_stdevfy1epsp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_stdevfy2epsp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fc_y2repsg, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fcfequity, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fcfghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fcfroi, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fcfsale, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fcfy3gc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fcghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fcoghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fixastto, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_flowratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fqsurstd60dlag, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_fwdebitdaev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_gear, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_grahamnum, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_gspea2y_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_gtl, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_gtlm6ghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ica, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_idb, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_indrelcroe_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_indrelrecd_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_indrelrtn4w_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_indrelrtn5d_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_inflation, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_invast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_iqa, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_irttmsalesev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_lagegp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_lasales, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_lfd, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_liqcoeff, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_lumqca, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_m42rav, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_m6dn2ntr, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_md, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_milliq, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mktcappera, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mktlev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mpg, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mpgghcy3_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mpgy3gc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mpn, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mpnghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mpoghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mpoy3gc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_mrspe_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nasales, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_netcashp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_netdebt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_netdebtebitda, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nfaldebt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_niper, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nla_u, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nlassets, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nlmc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nlmc_u, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nlprice, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nlprice_usd, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nlsales, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nlsales_usd, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nlvolcap, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nnastp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_noato, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_nopatmargin, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ntrm01ff, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_numrevy2, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ocfast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ocfmargin, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ocfratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ocfroi, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ohlsonscore, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_oilprice, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ollev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_opincltd, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_oplev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_otvni, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_p50_200ratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_past, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pau, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pb, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pbdwf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pbroeresidual, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pbwt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pca, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pcdwf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctabv260low, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchg3ycf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchg3yeps, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchg3yfcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchg3yocf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchgastto, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchgcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchgeps, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchgfcf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchgocf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchgqtrast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pctchgqtrsales, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pcurlia, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pcwt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pd09erpvc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pe_wt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pedu, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pedwf_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pelh_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_perg, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcf_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcfghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcfmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcfy3ghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcoghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcomtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcoy3ghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfcy3ghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pfgmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pge_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pi, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pinoa, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ppa, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pqipmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_prc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ps_wt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_psdwf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_psmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pspeghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pu, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_pvan, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rationalalpha, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ratrev6m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rau, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rdsale, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_reinrate, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rel5ybp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rel5ycfp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rel5ydivp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rel5yebitdap, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rel5yep, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rel5yfcfp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rel5yocfp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rel5ysp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_relpricestrength_, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rerror60m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rev3my1std, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rev3my2std, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rev6fy2, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_revper, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_roe, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_roic, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rq, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_rqi_rd, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_saleeps, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_saleg5y, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_salegpm, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_salerec, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_sh, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_sharechg, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_sighc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_sigma, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_skew90cortn, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_skew90drtn, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_slope4qeps5y, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_slope52wp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_slope66wp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_spe1yfvc_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_spe2yfvc_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_spefcn, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_speghc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_stockrating, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_surp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_susgrowth, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_tobinq, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_totalcov, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_totalsaleg, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_tstalp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ttmaccu, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ttmcapexp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ttmopincev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ttmsaleev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_tw_ebitdaev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_twepsrev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_twepsstdrev, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_varresirtn, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_vefcfmtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_vefcomtt, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_vesspem21f_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_visiratio, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_vnicw, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_vniu, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_voctni, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_volpre6m, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_volto, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_w57w03_rp, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_w62isr, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_w93ntr, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_wcast, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_xiv, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_y5speq4rqsr, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_y5speq4vc, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_ydp_cf, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_yen, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_yieldsprd, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_yoychgaa, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_yoychgcr, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_yoychgda, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_yoychggpm, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_yoychgroa, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_yoychgroeart, 120), std=4)', 'winsorize(ts_backfill(fnd65_pacific_sedol_yoychgroepct, 120), std=4)']\n"
     ]
    }
   ],
   "source": [
    "print(df[df['type'] == \"MATRIX\"][\"id\"].tolist())\n",
    "pc_fields = process_datafields(df, \"matrix\")\n",
    "print(pc_fields)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4)', 'ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 'ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 'ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 'ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 'ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 'ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 'ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 'ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 'ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)']\n",
      "57018\n"
     ]
    }
   ],
   "source": [
    "first_order = first_order_factory(pc_fields, ts_ops)\n",
    "print(first_order[:10])\n",
    "print(len(first_order))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "57018\n",
      "[('winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4)]\n"
     ]
    }
   ],
   "source": [
    "# Pad initial decay with alpha\n",
    "init_decay = 4\n",
    "fo_alpha_list = []\n",
    "for alpha in first_order:\n",
    "    fo_alpha_list.append((alpha, init_decay))\n",
    "print(len(fo_alpha_list))\n",
    "print(fo_alpha_list[:5])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[('winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4)], [('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_delta(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_delta(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_delta(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_delta(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4), ('ts_delta(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_sum(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_sum(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_sum(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_sum(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4)], [('ts_sum(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_product(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_product(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_product(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_product(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4), ('ts_product(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_ir(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_ir(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_ir(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_ir(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4)], [('ts_ir(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_std_dev(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_std_dev(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_std_dev(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_std_dev(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4), ('ts_std_dev(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_mean(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_mean(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_mean(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_mean(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4)], [('ts_mean(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_arg_min(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_arg_min(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_arg_min(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_arg_min(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4), ('ts_arg_min(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_arg_max(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_arg_max(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_arg_max(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_arg_max(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4)], [('ts_arg_max(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_min_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_min_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_min_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_min_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4), ('ts_min_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_max_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_max_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_max_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_max_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4)], [('ts_max_diff(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_returns(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_returns(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_returns(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_returns(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4), ('ts_returns(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_scale(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_scale(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_scale(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_scale(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4)], [('ts_scale(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_skewness(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_skewness(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_skewness(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_skewness(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4), ('ts_skewness(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_kurtosis(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_kurtosis(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_kurtosis(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_kurtosis(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4)], [('ts_kurtosis(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('ts_quantile(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 5)', 4), ('ts_quantile(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 22)', 4), ('ts_quantile(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 66)', 4), ('ts_quantile(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 120)', 4), ('ts_quantile(winsorize(ts_backfill(fnd65_allcap_sedol_52whigh, 120), std=4), 240)', 4), ('winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 5)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 22)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 66)', 4)], [('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 120)', 4), ('ts_rank(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 240)', 4), ('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 5)', 4), ('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 22)', 4), ('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 66)', 4), ('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 120)', 4), ('ts_zscore(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 240)', 4), ('ts_delta(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 5)', 4), ('ts_delta(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 22)', 4), ('ts_delta(winsorize(ts_backfill(fnd65_allcap_sedol_60dsigma, 120), std=4), 66)', 4)]]\n",
      "571\n"
     ]
    }
   ],
   "source": [
    "# Load alphas to task pools\n",
    "pools = load_task_pool(fo_alpha_list, 10, 10)\n",
    "print(pools[0])\n",
    "print(len(pools))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "b'{\"user\":{\"id\":\"JW80368\"},\"token\":{\"expiry\":14400.0},\"permissions\":[\"CONSULTANT\",\"MULTI_SIMULATION\",\"PROD_ALPHAS\",\"REFERRAL\",\"VISUALIZATION\",\"WORKDAY\"]}'\n",
      "pool 163 task 9 post done\n",
      "pool 163 task 9 simulate done\n",
      "pool 164 task 9 post done\n",
      "pool 164 task 9 simulate done\n",
      "pool 165 task 9 post done\n",
      "pool 165 task 9 simulate done\n",
      "pool 166 task 9 post done\n",
      "pool 166 task 9 simulate done\n",
      "pool 167 task 9 post done\n",
      "pool 167 task 9 simulate done\n",
      "pool 168 task 9 post done\n",
      "pool 168 task 9 simulate done\n",
      "pool 169 task 9 post done\n",
      "pool 169 task 9 simulate done\n",
      "pool 170 task 9 post done\n",
      "pool 170 task 9 simulate done\n",
      "pool 171 task 9 post done\n",
      "pool 171 task 9 simulate done\n",
      "pool 172 task 9 post done\n",
      "pool 172 task 9 simulate done\n",
      "pool 173 task 9 post done\n",
      "pool 173 task 9 simulate done\n",
      "pool 174 task 9 post done\n",
      "pool 174 task 9 simulate done\n",
      "pool 175 task 9 post done\n",
      "pool 175 task 9 simulate done\n",
      "pool 176 task 9 post done\n",
      "pool 176 task 9 simulate done\n",
      "pool 177 task 9 post done\n",
      "pool 177 task 9 simulate done\n",
      "pool 178 task 9 post done\n",
      "pool 178 task 9 simulate done\n",
      "pool 179 task 9 post done\n",
      "pool 179 task 9 simulate done\n",
      "pool 180 task 9 post done\n",
      "pool 180 task 9 simulate done\n",
      "pool 181 task 9 post done\n",
      "other\n"
     ]
    }
   ],
   "source": [
    "# Simulate First Order\n",
    "multi_simulate(pools, \"SUBINDUSTRY\", \"KOR\", \"TOP600\", 181, \"kor_fo_fund65_sub\")\n",
    "# 160/573 JPN_SUB_TOP1600\n",
    "# 182/571 KOR_SUB_TOP600"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = get_datafields(s, dataset_id='news85', region='USA', universe='TOP3000', delay=1)\n",
    "print(df[df['type'] == \"VECTOR\"][\"id\"].tolist())\n",
    "print(process_datafields(df, \"vector\"))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
